"candidate key" meaning in English

See candidate key in All languages combined, or Wiktionary

Noun

Forms: candidate keys [plural]
Head templates: {{en-noun}} candidate key (plural candidate keys)
  1. (computing, databases) In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key. Wikipedia link: candidate key Categories (topical): Computing, Databases Related terms: business key, foreign key, natural key, primary key, first normal form

Inflected forms

Alternative forms

{
  "forms": [
    {
      "form": "candidate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "candidate key (plural candidate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Computing",
          "orig": "en:Computing",
          "parents": [
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "glosses": [
        "In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "id": "en-candidate_key-en-noun-qIUmmEVO",
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "table",
          "table"
        ],
        [
          "column",
          "column"
        ],
        [
          "row",
          "row"
        ],
        [
          "CK",
          "CK"
        ],
        [
          "primary key",
          "primary key"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "related": [
        {
          "word": "business key"
        },
        {
          "word": "foreign key"
        },
        {
          "word": "natural key"
        },
        {
          "word": "primary key"
        },
        {
          "word": "first normal form"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "candidate key"
      ]
    }
  ],
  "word": "candidate key"
}
{
  "forms": [
    {
      "form": "candidate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "candidate key (plural candidate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "related": [
    {
      "word": "business key"
    },
    {
      "word": "foreign key"
    },
    {
      "word": "natural key"
    },
    {
      "word": "primary key"
    },
    {
      "word": "first normal form"
    }
  ],
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "Pages with 1 entry",
        "Pages with entries",
        "en:Computing",
        "en:Databases"
      ],
      "glosses": [
        "In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "table",
          "table"
        ],
        [
          "column",
          "column"
        ],
        [
          "row",
          "row"
        ],
        [
          "CK",
          "CK"
        ],
        [
          "primary key",
          "primary key"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "candidate key"
      ]
    }
  ],
  "word": "candidate key"
}

Download raw JSONL data for candidate key meaning in English (1.4kB)


This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-12-21 from the enwiktionary dump dated 2024-12-04 using wiktextract (d8cb2f3 and 4e554ae). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.